﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using DinhMuc.Public;
using System.Data;

namespace DinhMuc.DAL
{
   public class tblDangNhapQTDAL
    {
       clsConnect cn = new clsConnect();
       public DataTable getDangNhapQT_loc(tblDangNhapQTPublic p)
       {
           int para = 2;
           string[] name = new string[para];
           object[] value = new object[para];
           name[0] = "@userName";
           name[1] = "@pass";
           value[0] = p.UserName;
           value[1] = p.PassWork;
           return cn.LoadTable_loc("sp_quanLy_loc", name, value, para);
       }
       public int doiMatKhau(tblDangNhapQTPublic p)
       {
           int para = 2;
           string[] name = new string[para];
           object[] value = new object[para];
           name[0] = "@userName";
           name[1] = "@pass";
           value[0] = p.UserName;
           value[1] = p.PassWork;
           return cn.UpdateTableStore("sp_doiMatKhau_update", name, value, para);

       }
    }
}
